

*********************************************
****   Description   ************************
*********************************************

* This program generates the summary statistics table for the bank failures analysis, generating Panel B of "Table 8. Depositor Losses". 

 
*********************************************
****   Data *********************************
*********************************************

use "$Data/Bank_Failures_Data_December2024.dta", clear  

global variables year_failure total_claim_mil total_claim_mil_2021 claims_percent_gdp


*********************************************
****   Summary Statistics *******************
*********************************************

foreach x in $variables {
tabstat `x',  stat(mean p10 p25 p50 p75 p90)
} 


estpost tabstat $variables, statistics(mean sd p10 p25 p50 p75 p90) columns(statistics) 
 
estpost tabstat claims_percent_gdp, statistics(mean sd p10 p25 p50 p75 p90) columns(statistics) 
  